Tabela CO_L_DELIVERYORDERITEM

Definicja tabeli CO_L_DELIVERYORDERITEM

Name

CO_L_DELIVERYORDERITEM

Code

CO_L_DELIVERYORDERITEM

Comment

Tabela wi???ca wydania z pozycjami zam?wie? z oddzia??w


Lista kolumn tabeli CO_L_DELIVERYORDERITEM

Name

Code

CO_L_DELIVERYORDERITEMID

CO_L_DELIVERYORDERITEMID

CO_DELIVERYID

CO_DELIVERYID

CO_ORDERITEMID

CO_ORDERITEMID

INSERTDATE

INSERTDATE

INSERTINGPERSON

INSERTINGPERSON

LASTMODIFIEDPERSON

LASTMODIFIEDPERSON

LASTMODIFIEDDT

LASTMODIFIEDDT


Kolumna CO_L_DELIVERYORDERITEMID tabeli CO_L_DELIVERYORDERITEM

Definicja kolumny CO_L_DELIVERYORDERITEMID tabeli CO_L_DELIVERYORDERITEM

Name

CO_L_DELIVERYORDERITEMID

Code

CO_L_DELIVERYORDERITEMID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

klucz g??wny


Kolumna CO_DELIVERYID tabeli CO_L_DELIVERYORDERITEM

Definicja kolumny CO_DELIVERYID tabeli CO_L_DELIVERYORDERITEM

Name

CO_DELIVERYID

Code

CO_DELIVERYID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

identyfikator wydania, klucz obcy do CO_DELIVERY


Kolumna CO_ORDERITEMID tabeli CO_L_DELIVERYORDERITEM

Definicja kolumny CO_ORDERITEMID tabeli CO_L_DELIVERYORDERITEM

Name

CO_ORDERITEMID

Code

CO_ORDERITEMID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

identyfikator pozycji zam?wienia, klucz obcy do CO_ORDERITEM


Kolumna INSERTDATE tabeli CO_L_DELIVERYORDERITEM

Definicja kolumny INSERTDATE tabeli CO_L_DELIVERYORDERITEM

Name

INSERTDATE

Code

INSERTDATE

Data Type

DATE

Mandatory

No

Comment

 


Kolumna INSERTINGPERSON tabeli CO_L_DELIVERYORDERITEM

Definicja kolumny INSERTINGPERSON tabeli CO_L_DELIVERYORDERITEM

Name

INSERTINGPERSON

Code

INSERTINGPERSON

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LASTMODIFIEDPERSON tabeli CO_L_DELIVERYORDERITEM

Definicja kolumny LASTMODIFIEDPERSON tabeli CO_L_DELIVERYORDERITEM

Name

LASTMODIFIEDPERSON

Code

LASTMODIFIEDPERSON

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LASTMODIFIEDDT tabeli CO_L_DELIVERYORDERITEM

Definicja kolumny LASTMODIFIEDDT tabeli CO_L_DELIVERYORDERITEM

Name

LASTMODIFIEDDT

Code

LASTMODIFIEDDT

Data Type

DATE

Mandatory

No

Comment

 


Lista kluczy tabeli CO_L_DELIVERYORDERITEM

Name

Code

Primary

PK_CO_L_DELIVERYORDERITEM

PK_CO_L_DELIVERYORDERITEM

X


Klucz PK_CO_L_DELIVERYORDERITEM tabeli CO_L_DELIVERYORDERITEM

Definicja klucza PK_CO_L_DELIVERYORDERITEM tabeli CO_L_DELIVERYORDERITEM

Name

PK_CO_L_DELIVERYORDERITEM

Code

PK_CO_L_DELIVERYORDERITEM

Primary

Yes

Comment